play makAll work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All
HBAM2016AUG95
Pro 3.0
All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dullCopyright 1984-1996 Claris Corporation
and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy.
mark@
HBAM3016AUG95@
brandon
james
johnB
markB
Pro 3.0F!
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Helvetica
Geneva
1/27/97
CONSTANT
FIRST NAME
LAST NAME
SEARCH FIELD
SEARCH STORED
SEARCH VALUE
STATE
ZIP CODE
First NameB
A Last NameB
Zip CodeB
StateB
ConstantB
Search FieldB
Search ValueB
Search StoredB
Search StoredB
Helvetica
Geneva
First NameH
A Layout #1
A Layout #2
A Layout #2
ayout #2
First NameD Last NameF
StateH
Zip CodeM'Basic Contacts Demo file for SEARCH.FP3N
SearchO
Click the search button, enter your request and watch the magic happen. You could hook this premade solution up to your database within 30 minutes.P6Click here to find out how to connect to your databaseQ
Find AllRBTIP: Try drag-n-drop for finding things using the search database.S
LEGAL: This technique and file are (c) 1997 by ISO Productions / Matt Petrowsky. Commercial reproduction and use allowed only by license. Personal and Private use are free from license and or payment fees.
Helvetica
Geneva
A Layout #2B
type Text
3. Create a calculation field named Constant with a result of 1
What you must do to the SEARCH.FP3 database....
1. Create a relationship based on Constant
2. Set your specific search fields in Step 2 of SEARCH.FP3
C More Info
"You must duplicate the steps below
'into your own database. Their steps can
"be printed by printing the scripts
from the print dialog.
Search Button
------ SEARCH ROUTINE ------
Run Search Routine
( Step 1: Build Search from Global Copy
# Part A: Get Top Search String
Part B: Set Search Values
) Part C: Strip off top search string
A"You must duplicate the steps below
Helvetica
Geneva
Arial
A'into your own database. Their steps can
A"be printed by printing the scripts
from the print dialog.
Search Button
AiWhen a user clicks on the search button it prompts the search file to open up and run its opening script.
1. Create a global field called Search Field of type Text
2. Create a global field called Search Value of type Text
3. Create a global field called Search Stored of type Text
4. Create a calculation field named Constant with a result of 1
5. Duplicate the Search Routine scripts (found here) in your database and copy and paste the formulas from here
If you have questions please review the fields defined in this database and duplicate them in your own.
on in SEARCH.FP3 to call the Run Search Routine in your database
equests to My Database script in SEARCH.FP3
4. Edit the Perform Find button in SEARCH.FP3 to call the Run Search Routine in your database
Part B: Set Search Values
ps are basically the same. All you need to do is duplicate one for each field that you will be using to search on. This script will cycle through the field and if there is value in them already it will be skipped, if not then the search value is used. This can be extended to account for multiple requests on the same field but we have not shown that here.
= "First Name"
First Name
= "Last Name"
Last Name
= "State"
State
= "Zip"
A) Part C: Strip off top search string
") = 0
1) + 1
99999999)
uplicate one for each field that you will be using to search on. This script will cycle through the field and if there is value in them already it will be skipped, if not then the search value is used. This can be extended to account for multiple requests on the same field but we have not shown that here.
= "First Name"
First Name
= "Last Name"
Last Name
= "State"
State
tAll of these steps are basically the same. All you need to do is duplicate one for each field that you will be using to search on. This script will cycle through the field and if there is value in them already it will be skipped, if not then the search value is used. This can be extended to account for multiple requests on the same field but we have not shown that here.
= "First Name"
First Name
= "Last Name"
Last Name
= "State"
State
= "Zip"
) = 0
Cancel
oThere were no records found that match your search criteria.
= ""
A# Part A: Get Top Search String
1) - 1)
") = 0
1) + 1
99999999)
1) + 1
1) -
1) - 1)
A( Step 1: Build Search from Global Copy
= ""
A# Part A: Get Top Search String
1) - 1)
") = 0
1) + 1
99999999)
1) + 1
1) -
1) - 1)
ReturnD
Setting up the SEARCH.FP3 database should take
about 15-30 minutes and is well worth it. Play around
with this example to see how powerful it is.E`Print the scripts in this database and duplicate them in your own. But first follow these steps.ound
with this example to see how powerful it is.
markB
mickey
minmei
vince
bowers
cusick
fortier
krische
mennano
mouse
osborne
petrowsky
robins
robinson
35451
54165
54613
57654
65483
65716
67486
87946
98465
98468
98568
98745
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Pro 3.0F!
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
9What you must do to the SEARCH.FP3 database....
1. Create a relationship based on Constant
2. Set your specific search fields in Step 2 of SEARCH.FP3
3. Edit the Send Search Requests to My Database script in SEARCH.FP3
4. Edit the Perform Find button in SEARCH.FP3 to call the Run Search Routine in your database